About stored procedures and what are they?
May 25th, 2016
MYSQL 5 has introduced the feature called stored procedure, which is a set of SQL statements which can perform repetitive task. The stored proc...
MySQL Stored Procedures
Variables in stored procedures
May 25th, 2016
Variable is a data object. Its value can be changed during the execution of the stored procedure. The results of the procedure execution are stored in variables. To declare variable inside procedur...
Return values in stored procedures
May 25th, 2016
Stored procedure does not return a value using RETURN statement. But CALL statement gets the values of stored procedures
The IF statement in stored procedures
May 25th, 2016
The IF statements in MYSQL executes a block of code depending on the condition inside the IF statement, whether is true or false. The condition inside IF statement can be formed by...
The CASE statement in stored procedures
May 25th, 2016
The CASE statements are used to implement a complex conditional construct. The CASE statements are declared in two ways:
CASE caseValue
&nb...
What is MySQL cursor?
May 25th, 2016
MySQL Cursors exist and are set to traverse in datasets, returned by...
MYSQL Stored Functions
May 25th, 2016
A stored function in MySQL encapsulates user defined formulas that can be reused amon...
